Skip to content

SQL - MySQL Complete Masterclass™: SQL Bootcamp for Data Analytics From Zero to Expert

Learn SQL & MySQL for Data Analytics, Business Intelligence, Marketing, Real-World Projects Report w/ Tableau & Python

99masterclass

Summary

Price
£499 inc VAT
Or £55.44/mo. for 9 months...
Study method
Online, On Demand What's this?
Duration
19.4 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
Additional info
  • Tutor is available to students
8 students purchased this course

Add to basket or enquire

Overview

Hello and welcome to MySQL Complete Masterclass™ | SQL Bootcamp From Beginner to Expert [2022]

Learn and understand the skills you need to become a master of SQL & MySQL using real-world projects. Learn to build real-life data analytic reports with complex queries. Start learning from scratch to advanced topics in SQL with Instructor support: Ask questions and get quick responses.

This course is updated frequently with new lessons, projects, and resources!

Start Learning SQL TODAY!

#Reviews about this course

★★★★★ "This course was very in-depth, it does take a lot of time and focus but was certainly worth it. I would highly recommend it to anyone that is looking to further advance or start a SQL career."

★★★★★ "Thanks for sharing such valuable information."

★★★★★ "It's an interesting well explained course for the beginners with enough practice material to get a hold on concepts. I am building more & more knowledge & interest at each micro-step"

★★★★★ "Such a great match! So far he explains it in lamen's terms that are incredibly easy to understand. I am looking forward to more!"

★★★★★ "It is a great opportunity to learn valuable things which can boost you for a perfect job. The Instructor has the talent to transfer the knowledge. Watch the videos, Practice more and more. One of my best courses. Probably the best!"

★★★★★ "I learned a lot of stuff. This course contains a lot of information and is well organized. Really good teacher!"

Curriculum

86
sections
411
lectures
19h 25m
total

    • 1: For Absolute Beginner: SQL vs MySQL vs DBMS and Database vs Data 11:13
    • 2: For Absolute Beginner: Why Choosing MySQL? 04:39

    • 3: Installation of MySQL on MacOS 05:43
    • 4: RESOURCES for Installation of MySQL on MacOS 01:00
    • 5: How to fix Cannot Connect to MySQL Server - MacOS 02:36
    • 6: Installation of MySQL Server and Workbench on Windows 03:23
    • 7: How to fix Cannot Connect to MySQL Server - Windows 02:29

    • 8: Database Resources for this Course 01:00

    • 9: SELECT (Understanding Select for Absolute beginners) 13:09

    • 10: Database vs Table In SQL- Layman Explanation - Challenge & Solution 03:57
    • 11: Creating A Database - Challenge & Solution 1 00:28
    • 12: IF NOT EXISTS_ with CREATE DATABASE - Challenge & Solution 2 01:26
    • 13: How To Check For Existing Databases - Challenge & Solution 3 00:41
    • 14: How To Delete A Database - Challenges & Solution 4 01:03
    • 15: Using A Database - Challenge & Solution 5 02:05
    • 16: How To Check For The Selected Database in Use - Challenge & Solution 6 00:36

    • 17: First Things First - TABLES 19:10
    • 18: IF NOT EXISTS with CREATE TABLE in SQL - MySQL 03:30
    • 19: Purpose of ( ); In CREATE TABLE In SQL-MySQL 01:40
    • 20: Backticks In CREATE TABLE In SQL-MySQL 04:39
    • 21: CREATE TABLE In SQL-MySQl - First Time 02:40

    • 22: Type of Data in MySQL 01:38
    • 23: MySQL Numeric Types 02:47
    • 24: TINYINT SMALLINT MEDIUMINT INTEGER BIGINT - Exact Numeric Data Types in MySQL 14:50
    • 25: DECIMAL & NUMERIC - Fixed Point Data Types in MySQL - Approximate Numeric I 08:46
    • 26: DECIMAL & NUMERIC - Fixed Point Data Types in MySQL - Approximate Numeric II 11:10
    • 27: REAL FLOAT DOUBLE - Floating Point Data Type in MySQL 07:26
    • 28: CHAR vs VARCHAR - String Data Types in MySQL 05:24
    • 29: BINARY & VARBINARY - String Data Types in MySQL 03:45
    • 30: BLOB & TEXT - String Data Types in MySQL 01:07
    • 31: ENUM - String Data Types in MySQL 03:44
    • 32: SET - String Data Types in MySQL 03:00
    • 33: DATE TIME DATETIME TIMESTAMP & YEAR - Date and Time Data Types in MySQL 03:49

    • 34: Inserting A Single Line of Data Into Table - 1st Method 01:26
    • 35: Inserting A Single Line of Data Into Table - 2nd Method 00:43
    • 36: Inserting Multiple Lines of Data Into Table - 1st Method 00:46
    • 37: Inserting Multiple Lines of Data Into Table - 2nd Method 01:42
    • 38: Inserting Multiple Lines of Data Into Table - 3rd Method 00:53
    • 39: Inserting Null Value and Empty White Space Into Table 03:50

    • 40: Candidate Key In SQL 03:09
    • 41: Surrogate Key In SQL 01:52
    • 42: Primary Key & Alternative Key In SQL 03:59
    • 43: Foreign Key In SQL 04:29

    • 44: Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution 1 03:39
    • 45: Deleting A PRIMARY KEY - Challenge & Solution 2 02:19
    • 46: Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3 01:45
    • 47: Assigning A FOREIGN KEY - Challenge & Solution 4 06:43
    • 48: Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5 02:50
    • 49: Adding A FOREIGN KEY To Existing Table - Challenge & Solution 6 02:47
    • 50: Challenge & Solution 7 _ CONSTRAINT NAME & FOREIGN KEY To Existing Table 02:35
    • 51: Deleting A REFERENCED Parent Table - Challenge & Solution 8 02:19
    • 52: Deleting A Column From A Table - Challenge & Solution 9 01:08
    • 53: Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10 03:02

    • 54: Select All Rows and Columns - Challenge & Solution 1 02:25
    • 55: Select Specific Columns - Challenge & Solution 2 01:28
    • 56: Manager Demands for All Customers Detail - Challenge & Solution 3 00:43
    • 57: Specific Customer's Details - Challenge & Solution 4 00:32

    • 58: ALIAS (AS) Introduction 04:24
    • 59: Alias - Challenge & Solution 02:13

    • 60: CONCAT() Introduction 01:10
    • 61: CONCAT() - Challenge & Solution 1 00:33
    • 62: CONCAT() - Challenge & Solution 2 02:28

    • 63: ORDER BY Introduction 03:47
    • 64: ORDER BY ASC - Challenge & Solution 1 02:03
    • 65: ORDER BY ASC - Challenge & Solution 2 01:50
    • 66: ORDER BY DESC & CONCAT - Challenge & Solution 3 02:57
    • 67: ORDER BY ASC - Challenge & Solution 4 01:19

    • 68: LIMIT - Challenge & Solution 1 01:04
    • 69: LIMIT - Challenge & Solution 2 01:20
    • 70: LIMIT - Challenge & Solution 3 00:53

    • 71: ORDER BY with RAND - Challenge & Solution 01:17

    • 72: SINGLE & MULTILINE COMMENTS in SQL-MySQL 03:25

    • 73: Introduction to WHERE 03:19
    • 74: UK Customers filter - Challenge & Solution 1 02:59
    • 75: Specific Customer filter - Challenge & Solution 2 00:31
    • 76: Specific Employee filter - Challenge & Solution 3 00:35
    • 77: Product with specific Price filter - Challenge & Solution 4 00:48
    • 78: Getting a list of Sales Representatives - Challenge & Solution 5 00:52
    • 79: None Spanish Customers using != , __ - Challenge & Solution 6 02:38
    • 80: Products Supplied by a Specific Customer - Challenge & Solution 7 00:38
    • 81: All Suppliers Except... using NOT, __, ! - Challenge & Solution 8 01:42
    • 82: Products above certain Price _ Greater Than _ - Challenge & Solution 9 00:52
    • 83: Products Below Certain Price_ Less Than _ - Challenge & Solution 10 00:40
    • 84: Unit In Stock _ Less Than _ - Challenge & Solution 11 01:00
    • 85: Minimum Wages _ Less Than _ - Challenge & Solution 12 00:40
    • 86: Gifts for Customers _ Greater Than - Challenge & Solution 13 02:11
    • 87: Units In Stock _ Less Than - Challenge & Solution 14 01:27
    • 88: San Francisco Customers _ AND - Challenge & Solution 15 02:25
    • 89: Specific Mexico Customers _ AND - Challenge & Solution 16 01:38
    • 90: None USA and UK Customers _ NOT, !=, __ - Challenge & Solution 17 02:34
    • 91: Brazil and Venezuela Customers _ OR - Challenge & Solution 18 01:52
    • 92: Range of Suppliers _ BETWEEN - Challenges & Solution 19 01:10
    • 93: Suppliers _ Combining _, _ & OR - Challenge & Solution 20 00:32
    • 94: Range of Suppliers using BETWEEN - Challenge & Solution 21 01:14
    • 95: NOT BETWEEN - Challenge & Solution 22 00:36
    • 96: Customers in Paris & Nantes, France - Challenge & Solution 23 02:27
    • 97: Product List _ BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24 01:29
    • 98: NULL values _ IS NULL, IS NOT NULL - Challenge & Solution 25 01:10
    • 99: Employees Report to #2 _ IS NOT NULL - Challenge & Solution 26 02:25
    • 100: IN and WHERE - Challenge & Solution 27 01:48
    • 101: NOT IN - UK, Germany & France Customers - Challenge & Solution 28 01:55

    • 102: Introduction to MySQL Index 03:26
    • 103: Creating Index Along a Table 01:22
    • 104: Creating Index on Existing Column 01:04
    • 105: Understanding Primary or Clustered Index 04:36
    • 106: Unique Key vs Index 02:09
    • 107: Key vs Index 02:50
    • 108: Verifying Index 02:03
    • 109: Confirming the _Power_ of Index 04:11
    • 110: Deleting Index 01:18

    • 111: Introduction to MySQL Wildcards 06:38
    • 112: MySQL Wildcard - Customers Start With P - Challenges & Solution 1 01:19
    • 113: MySQL Wildcard _ Employees In Sales - Challenges & Solution 2 01:45
    • 114: MySQL Wildcard _ Phone Number Pattern - Challenges & Solution 3 02:48
    • 115: MySQL Wildcard - Customers In Restaurant Business - Challenges & Solution 4 00:43
    • 116: MySQL Wildcard - NOT LIKE - -Challenges & Solution 5 01:04

    • 117: Updating a Single Value in a Table 04:37
    • 118: Updating Multiple Values in a Table 01:39
    • 119: Using UPDATE with REPLACE 04:05
    • 120: What is Storage Engine - Let's Digress a little 02:59

    • 121: DISTINCT - How it works 02:52
    • 122: DISTINCT, ORDER BY DESC, WHERE, IS NOT - Challenge & Solution 02:23

    • 123: How Format() Function Works 01:29
    • 124: Data Cleaning _ Format - Challenge & Solution 00:58

    • 125: GROUP BY - True Meaning (1) 10:02
    • 126: MIN(), MAX(), AVG(), SUM() & GROUP BY - Challenge & Solution 1 (1) 03:31
    • 127: GROUP BY _ SUM,MIN,AVG _ CONCAT _ FORMAT - Challenge & Solution 2 (1) 02:03
    • 128: Region Count _ GROUP BY, COUNT - Challenge & Solution 3 (1) 01:54
    • 129: Row _ Unique Value Count _ GROUP BY, COUNT - Challenge & Solution 4 (1) 02:40
    • 130: Product Count _ COUNT, GROUP BY, ORDER BY - Challenge & Solution 5 (1) 05:02
    • 131: Product Sold _ SUM, GROUP BY - Challenge & Solution 6 (1) 02:27
    • 132: Most Hardworking Employee - Challenge & Solution 7 (1) 03:11
    • 133: Group By Most HandWorking Employee (1) 03:11

    • 134: Purpose of JOIN in SQL 03:11
    • 135: Type of JOIN in SQL 01:02
    • 136: Understanding INNER JOIN 04:35
    • 137: Understanding LEFT JOIN 04:42
    • 138: Understanding RIGHT JOIN 03:53
    • 139: Understanding FULL JOIN 03:12

    • 140: Overview of Tables & Code for JOIN Demonstration 01:43
    • 141: INNER JOIN - DEEP DIVE 21:03
    • 142: LEFT JOIN - DEEP DIVE 15:08
    • 143: RIGHT JOIN - DEEP DIVE 06:02
    • 144: More On RIGHT JOIN and LEFT JOIN with Shipper & Orders tables 07:45
    • 145: Table.Column vs Column only 14:16

    • 146: ON vs WHERE in INNER, LEFT & RIGHT JOIN 06:42
    • 147: ON vs USING in SQL JOIN Statement 03:38

    • 148: JOIN for Orders Handled_Managed By Employee - Challenge & Solution 1 04:31
    • 149: Using JOIN for Products & Their Suppliers - Challenge & Solution 2 03:23
    • 150: JOIN for Customers and Shippers - Challenge & Solution 3 01:56
    • 151: JOIN Many Tables - Customers and Names of Shipper - Challenge & Solution 4 04:54

    • 152: Resource for 2 03:00 PDF
    • 153: Simplifying the Schema used for JOIN in the following sections. 05:27

    • 154: Self-Join _ One Table Join - Challenge and Solution 1 06:25

    • 155: Two Tables Join - Challenge and Solution 2 01:21
    • 156: Two Tables Join - Challenge and Solution 3 02:04
    • 157: Two Tables Join - Challenge and Solution 4 01:05
    • 158: Two Tables Join - Challenge and Solution 5 02:39

    • 159: Three Table Joins - Challenge and Solution 6 02:16
    • 160: Three Tables Join - Challenge and Solution 7 01:20

    • 161: Four Tables Join - Challenge and Solution 8 03:41

    • 162: Five Tables Join - Challenge and Solution 9 05:35
    • 163: Five Tables Join - Challenge and Solution 10 02:47

    • 164: Six Tables Join - Challenge and Solution 11 01:29

    • 165: Seven Tables Join - Challenge and Solution 12 01:40

    • 166: Eight Tables Join - Challenge and Solution 13 01:30

    • 167: Nine Tables Join - Challenge and Solution 14 03:03

    • 168: Ten Tables Join - Challenge and Solution _ For Demonstration Purpose 01:11

    • 169: Offset & Limit - Challenge & Solution 1 06:22
    • 170: Offset & Limit _ Third Highest Purchase - Challenge & Solution 2 02:38
    • 171: Offset & Limit _ First Three Highest Salary - Challenge & Solution 3 01:00
    • 172: Offset & Limit - Fourth to the Lowest Salary - Challenge & Solution 4 01:15
    • 173: OFFSET & LIMIT _ First and Third Bestselling Products - Challenge & Solution 5 02:20

    • 174: Understanding MySQL CASE 06:31
    • 175: CASE with IS NULL 02:23
    • 176: CASE FOR TYPE OF CUSTOMERS 06:52

    • 177: CAST - FROM STRING to DATE 01:03
    • 178: CAST - FROM INTEGER to CHAR - Challenge & Solution 2 00:22
    • 179: CAST _ FROM STRING to DATE & TIME - Challenge & Solution 3 00:56
    • 180: 4 CAST _ FROM STRING to TIME - Challenge & Solution 4 00:32
    • 181: 5 CAST _ Order Date Without time - Challenge & Solution 5 01:07
    • 182: 6 CAST _ FROM DATE to DATETIME - Challenge & Solution 6 01:44

    • 183: Introduction to subqueries 04:09
    • 184: Aggregate Function with Subqueries 04:19
    • 185: Nested Subquery - Challenge & Solution 1 04:05
    • 186: Many Subqueries - Challenges & Solution 2 06:01

    • 187: Exists Operator 01:10
    • 188: Subquery & Exists - Challenge & Solution 1 04:34
    • 189: Subquery & Exists - Challenge & Solution 2 05:45

    • 190: Difference Between Nested and Correlated Subquery 09:41

    • 191: SPACE FUNCTION Challenge & Solution 1 00:57
    • 192: SPACE FUNCTION Challenge & Solution 2 01:02
    • 193: REPEAT FUNCTION Challenge & Solution 3 00:37
    • 194: REPEAT FUNCTION Challenge & Solution 4 02:10
    • 195: REPLACE FUNCTION Challenge & Solution 5 01:05
    • 196: REPLACE FUNCTION Challenge & Solution 6 00:52
    • 197: REPLACE FUNCTION Challenge & Solution 7 02:23
    • 198: REVERSE FUNCTION Challenge & Solution 8 00:56
    • 199: REVERSE FUNCTION Challenge & Solution 9 02:18
    • 200: LEFT FUNCTION Challenge & Solution 10 01:54
    • 201: LEFT FUNCTION Challenge & Solution 11 01:43
    • 202: RIGHT FUNCTION Challenge & Solution 12 00:51
    • 203: RIGHT FUNCTION Challenge & Solution 13 02:04
    • 204: RPAD FUNCTION _ Challenge & Solution 14 01:32
    • 205: RPAD FUNCTION Challenge & Solution 15 03:35
    • 206: LPAD FUNCTION Challenge & Solution 16 01:52
    • 207: LPAD FUNCTION Challenge & Solution 17 02:35
    • 208: LPAD FUNCTION Challenge & Solution 18 04:59
    • 209: POSITION & LOCATION FUNCTIONS Challenge & Solution 19 01:56
    • 210: POSITION & LOCATION FUNCTIONS Challenge & Solution 20 01:24
    • 211: SUBSTRING_SUBSTR FUNCTION Challenge & Solution 21 03:18
    • 212: SUBSTRING_SUBSTR FUNCTION Challenge & Solution 22 01:31
    • 213: SUBSTRING_SUBSTR FUNCTION Challenge & Solution 23 02:53
    • 214: SUBSTRING_SUBSTR FUNCTION Challenge & Solution 24 04:17
    • 215: SUBSTRING_INDEX FUNCTION Challenge & Solution 25 01:43
    • 216: SUBSTRING_INDEX FUNCTION Challenge & Solution 26 01:02
    • 217: SUBSTRING_INDEX FUNCTION Challenge & Solution 27 01:22
    • 218: SUBSTRING_INDEX FUNCTION Challenge & Solution 28 01:11
    • 219: SUBSTRING_INDEX FUNCTION Challenge & Solution 29 03:08
    • 220: MID FUNCTION Challenge & Solution 30 01:09
    • 221: MID FUNCTION Challenge & Solution 31 01:15
    • 222: INSERT FUNCTION Challenge & Solution 32 03:26
    • 223: INSERT FUNCTION Challenge & Solution 33 01:32
    • 224: INSTR FUNCTION Challenge & Solution 34 01:32
    • 225: INSTR FUNCTION Challenge & Solution 35 01:11
    • 226: LCASE & LOWER FUNCTION Challenge & Solution 36 00:56
    • 227: LCASE & LOWER FUNCTION Challenge & Solution 37 00:35
    • 228: UCASE & UPPER FUNCTION Challenge & Solution 38 00:36
    • 229: UCASE & UPPER FUNCTION Challenge & Solution 39 00:57
    • 230: UCASE & UPPER FUNCTION Challenge & Solution 40 00:55
    • 231: LENGTH FUNCTION _ Challenge & Solution 41 01:03
    • 232: LENGTH FUNCTION Challenge & Solution 42 01:02
    • 233: LTRIM FUNCTION Challenge & Solution 43 02:04
    • 234: LTRIM FUNCTION Challenge & Solution 44 01:35
    • 235: RTRIM FUNCTION Challenge & Solution 45 01:08
    • 236: RTRIM FUNCTION Challenge & Solution 46 01:18
    • 237: TRIM FUNCTION Challenge & Solution 47 01:47
    • 238: TRIM FUNCTION Challenge & Solution 48 00:49

    • 239: Understanding MySQL Session 03:25

    • 240: Table Locking Introduction 01:51
    • 241: Table Locking Demonstration 04:40

    • 242: Brief Introduction to SQL Transaction 03:03
    • 243: TRANSACTION components - START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET 01:54
    • 244: TRANSACTION By Example 06:10
    • 245: NOT USING TRANSACTION 01:27
    • 246: ROLLBACK 05:16

    • 247: Meaning of VIEW 04:35
    • 248: VIEW for Sales Manager Challenge & Solution 1 02:03
    • 249: VIEW for Employees hired in 1994 Challenge & Solution 2 02:26
    • 250: 4 Updating VIEW Challenge & Solution 3 02:48
    • 251: A Mistake In VIEW Challenge & Solution 4 02:21
    • 252: Deleting a VIEW Challenge & Solution 5 01:32
    • 253: VIEW for Japan Suppliers Challenge & Solution 6 01:15
    • 254: WHERE with Normal Table & VIEW Table Challenge & Solution 7 05:03
    • 255: INNER JOIN with Normal Table & VIEW Table Challenge & Solution 8 01:40

    • 256: What is the meaning and purpose of Stored Procedure 07:03
    • 257: How to create STORED PROCEDURE for cars table - Challenge & Solution 2 10:53
    • 258: How to Modify STORED PROCEDURE _ Tesla Vehicles - Challenge & Solution 3 07:13
    • 259: How to check for STORED PROCEDURE across databases - Challenge & Soln 4 00:46
    • 260: Check for STORED PROCEDURE in the current database - Challenge & Solution 5 01:26
    • 261: Check for STORED PROCEDURE in a specified database - Challenge & Soln 6 01:54
    • 262: Deleting a STORED PROCEDURE - Challenge & Solution 7 01:28
    • 263: STORED PROCEDURE - Helping Purchasing Manager - Challenge & Solution 8 13:09
    • 264: STORED PROCEDURE for Most Expensive Car - Challenge & Solution 9 08:39
    • 265: STORED PROCEDURE for DATA INSERT to a table - Challenge & Solution 10 06:12

    • 266: What is FUNCTION in SQL 02:02
    • 267: Creating Addition FUNCTION - Challenge & Solution 2 06:56
    • 268: How to check for FUNCTION - Challenge & Solution 3 01:34
    • 269: Creating Pythagoras Theorem FUNCTION - Challenge & Solution 4 03:36
    • 270: Altering or Updating FUNCTION - Challenge & Solution 04:36
    • 271: Creating FUNCTION for Order details Line Total - Challenge & Solution 6 05:34
    • 272: Deleting a FUNCTION - Challenge & Solution 7 01:42

    • 273: The Purpose, The How and Types of TRIGGER 05:32
    • 274: TRIGGER - More Explanation With Diagram 03:31
    • 275: Steps to Creating a TRIGGER - Challenge & Solution 1a 08:15
    • 276: Creating After Update TRIGGER - Challenge & Solution 1b 09:28
    • 277: How to Check and Delete a TRIGGER - Challenge & Solution 1c 00:37
    • 278: Creating After Update TRIGGER - Another Method - Challenge & Solution 1d 06:31
    • 279: Creating Conditional Update TRIGGER _ Different Names - Challenge & Solution 2 09:10
    • 280: Creating AfterUpdate MySQL TRIGGER _ Above USD$5k - Challenge & Solution 3 07:23
    • 281: After Insert Error Message MySQL TRIGGER - Challenge & Solution 4 04:09
    • 282: TRIGGER with SIGNAL SQLSTATE for Null Value - Challenge & Solution 5 07:14
    • 283: Multiple lines of TRIGGER - Many in One - Challenge & Solution 6 06:51
    • 284: SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER - Challenge & Solution 7 03:05
    • 285: Fraud Detection - After Delete TRIGGER - Challenge & Solution 8 04:04

    • 286: Setting up database for challenges with attached downloadable resource 01:15
    • 287: Nested Subquery & JOIN methods _ _ 1million - Challenge & Solution 1 03:58
    • 288: Nested Subquery _ Budget above average - Challenge & Solution 2 01:47
    • 289: Nested Subquery & More Query Tweaking - Challenge & Solution 3 13:13
    • 290: Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4 09:28

    • 291: Intro 00:18
    • 292: CarShop Resource Details 03:02
    • 293: Fetching Names of Cars - Challenge & Solution 1 00:33
    • 294: Names & Price of Cars - Challenge & Solution 2 00:21
    • 295: Cars at a specific price - Challenge & Solution 3 00:31
    • 296: Between two prices of cars - Challenge & Solution 4 01:32
    • 297: Counting Cars - Challenge & Solution 5 00:42
    • 298: Price List of Cars - Challenge & Solution 6 01:13
    • 299: Price List For Cambodia Customers - Challenge & Solution 7 08:26
    • 300: Car Average Price - Challenge & Solution 8 00:32
    • 301: The most expensive car - Challenge & Solution 9 01:01
    • 302: Most Expensive Cars - Challenge & Solution 10 06:18
    • 303: Honda & Toyota - Challenge & Solution 11 02:07
    • 304: All details from two tables - Challenge & Solution 12 01:18
    • 305: Specific fields from two tables - Challenge & Solution 13 01:31
    • 306: Counting Cars Per Manufacturer - Challenge & Solution 14 04:35
    • 307: Average Price Per Manufacturer - Challenge & Solution 15 01:38
    • 308: Manufacturer Average Car Price Above $35,000 - Challenge & Solution 16 01:07
    • 309: The Cheapest Car - Challenge & Solution 17 01:59
    • 310: The Most Expensive Car - Challenge & Solution 18 05:21
    • 311: Data Insert - Challenge & Solution 19 02:00
    • 312: Correcting Wrong Data - Challenge & Solution 20 00:49
    • 313: Discounted Prices I - Challenge & Solution 21 02:33
    • 314: Discounted Price II - Challenge & Solution 22 01:07
    • 315: VIEW for price list - Challenge & Solution 23 04:50

    • 316: !Intro 00:35
    • 317: What is the current database selected_ - Assignment 1 00:04
    • 318: What is the current database selected_ - Assignment 1 Solution 00:40
    • 319: What are the available tables in the database_ - Assignment 2 00:05
    • 320: What are the available tables in the database_ - Assignment 2 Solution 00:17
    • 321: Display the details of each of the table in the database - Assignment 3 00:09
    • 322: Display the details of each of the table in the database -Assignment 3 Solutio 01:51
    • 323: SQL Query to retrieve data from one table - Assignment 4 00:06
    • 324: SQL Query to retrieve data from one table - Solution to Assignment 4 00:24
    • 325: Using Alias - Assignment 5 00:08
    • 326: Using Alias - Solution to Assignment 5 00:58
    • 327: Retrieving data across two tables using JOIN - Assignment 6 00:57
    • 328: Retrieving data across two tables using JOIN - Solution to Assignment 6 03:09
    • 329: Retrieving data across three tables using JOIN - Assignment 7 00:34
    • 330: Retrieving data across three tables using JOIN - Solution to Assignment 7 02:39
    • 331: Aggregate - sum, average, minimum, maximum - Assignment 8 00:12
    • 332: Aggregate - sum, average, minimum, maximum - Solution to Assignment 8 02:07
    • 333: GROUP BY & Average - Assignment 9 00:14
    • 334: GROUP BY & Average - Solution to Assignment 9 03:57
    • 335: GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Assignment 10 00:53
    • 336: GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Solution to Assignment 10 08:12
    • 337: VIEW for three tables JOIN - Assignment 11 00:20
    • 338: VIEW for three tables JOIN - Solution to Assignment 11 02:54
    • 339: INNER JOIN, Subquery & EXISTS - Assignment 12 00:07
    • 340: INNER JOIN, Subquery & EXISTS - Solution to Assignment 12 00:52
    • 341: Updating Table with 5% Increase in Salary - Assignment 13 00:13
    • 342: 25 Updating Table with 5% Increase in Salary - Solution Assignment 13 02:54
    • 343: INNER JOIN and SubQuery - Assignment 14 00:13
    • 344: INNER JOIN and SubQuery - Solution Assignment 14 02:12
    • 345: INNER JOIN & AND - Assignment 15 00:11
    • 346: INNER JOIN & AND - Solution Assignment 15 02:52
    • 347: INNER JOIN & SubQuery - Assignment 16 00:10
    • 348: INNER JOIN & SubQuery - Solution to Assignment 16 02:18
    • 349: SUBQUERY & LIMIT - Assignment 17 00:11
    • 350: SUBQUERY & LIMIT - Solution to Assignment 17 02:54
    • 351: UCASE - Assignment 18 00:11
    • 352: UCASE - Solution to Assignment 18 00:17

    • 353: Employees With Same Salary - Task 1 00:09
    • 354: Solution - Employees With Same Salary - Task 1 07:07

    • 355: Duplicate Title - Task 2 00:09
    • 356: Solution - Duplicate Title - Task 2 01:08

    • 357: Excluding Titles - Task 3 00:10
    • 358: Solution - Excluding Titles - Task 3 00:29

    • 359: Eight & Last Alphabet 'n' - Task 4 00:12
    • 360: Solution - Eight & Last Alphabet 'n' - Task 4 00:35

    • 361: Even Rows - Task 5 00:07
    • 362: Solution - Even Rows - Task 5 00:55

    • 363: Odd Rows - Task 6 00:06
    • 364: Solution - Odd Rows - Task 6 00:47

    • 365: Second to Fourth - Task 7 00:10
    • 366: Solution - Second to Fourth - Task 7 00:32

    • 367: Counting Employee with _SALES_ - Task 8 00:08
    • 368: Solution - Counting Employee with _SALES_ - Task 8 00:18

    • 369: Using Sub Query - Second to the Highest Salary - Task 9 00:12
    • 370: Solution - Using Sub Query - Second to the Highest Salary - Task 9 02:00

    • 371: Tricky Exercise - Task 10 00:10
    • 372: Solution - Tricky Exercise - Task 10 01:02

    • 373: Tricky Exercise - Task 11 00:37
    • 374: Solution - Tricky Exercise - Task 11 03:00

    • 375: Tricky Exercise - Task 12 00:15
    • 376: Solution - Tricky Exercise - Task 12 08:40
    • 377: Tricky Exercise - Task 12b 00:19
    • 378: Solution - Tricky Exercise - Task 12b 00:36

    • 379: Tricky Exercise - Task 13 00:15
    • 380: Solution - Tricky Exercise - Task 13 06:23

    • 381: Tricky Exercise - Task 14 00:15
    • 382: Solution - Tricky Exercise - Task 14 02:56

    • 383: Using Fewer Columns From SUBQUERY With JOIN 05:39
    • 384: Using WITH, SUBQUERY & INNER JOIN 02:37

    • 385: Solution - Tricky Exercise - task 16 00:36
    • 386: Solution - Tricky Exercise - Task 15 06:49

    • 387: Tricky Exercise - task 16 00:09
    • 388: Solution - Tricky Exercise - task 16 00:28

    • 389: Tricky Exercise - Task 17 00:16
    • 390: Solution - Tricky Exercise - Task 17 07:09

    • 391: Tricky Exercise - Task 18 00:46
    • 392: Solution - Tricky Exercise - Task 18 05:45

    • 393: Installation of MySQL Connector for Python 02:34

    • 394: Creating Database & Show Databases From Python 06:02
    • 395: Creating a Table, Show Table & Describe Table 01:24

    • 396: Insert A Row of Data Into A Table & Select 02:30
    • 397: Insert Multiple Rows of Data Into A Table 03:28

    • 398: Counting the numbers of rows 00:41
    • 399: FetchOne vs FetchAll 01:17

    • 400: Select Filter with Python 01:07
    • 401: SQL Wildcard with Python 03:08

    • 402: Business Intelligence - Introduction & Definition 01:51
    • 403: Business Intelligence Process 03:14

    • 404: How to Download and Install Tableau 01:04

    • 405: Tableau - What-Is-What In Tableau - I 02:22
    • 406: Tableau - What-Is-What In Tableau - II 08:12
    • 407: Tableau - What-Is-What In Tableau - III 01:24

    • 408: Connecting MySQL to Tableau 04:30

    • 409: Tableau & MySQL - Querying SQL Database from Tableau 03:50
    • 410: Tableau & MySQL - Visualising CarShop Dataset 01:25

    • 411: Tableau & SQL Challenge - Gross Sales and Net Sales Report 06:14

Course media

Description

This course covers all the following (and many more) both the theory, practical with hands-on exercises with the solutions:

  • Introduction to SQL
  • Installation MySQL
  • Select Statement
  • Database
  • Table
  • Data Types
  • Insert Query
  • Candidate, Surrogate, Primary, Alternative & Foreign Key
  • Primary and Foreign Key Constraints | Alter Table
  • Alias (AS)
  • Concat Function
  • Order By Keyword
  • Limit Clause
  • Order By & Rand Function
  • Comments
  • Where Clause
  • Index
  • Wildcards
  • Update Statement & Replace Function
  • Select Distinct Statement
  • Format Function
  • Group By Statement | Aggregate
  • Inner Join
  • Left Join
  • Right Join
  • Self Join
  • Two Tables Join
  • Three Tables Join
  • Four Tables Join
  • Five Tables Join
  • Six Tables Join
  • Seven Tables Join
  • Eight Tables Join
  • Nine Tables Join
  • Ten Tables Join
  • Offset & Limit
  • Case Function
  • Cast Function
  • Nested & Correlated Subqueries
  • Subqueries & Exits Operator
  • String Function
  • Session
  • Table Locking
  • Transaction
  • View
  • Stored Procedures (Stored Routines)
  • User-Defined Functions (Stored Routine)
  • Triggers
  • Combining SQL and Python
  • Combining SQL and Tableau
  • Research Data Set - Real-World Datasets
  • CAR SHOP DATA SET - Real-World Datasets
  • CAMERA SUPPLIERS - Real-World Datasets



With all of the above and many more plus the support, assistance, and guidance of the instructor throughout this complete high-quality guide you will gain numerous skills that will boost your career.

Your understanding of SQL through MySQL is highly valuable.

Whether you are a beginner or a professional desiring to gain more knowledge in SQL, this course is for you. You will be learning from experts with over two decades of experience.

What are you waiting for, enrol now and let's get started!

Who is this course for?

  • For Beginner, Intermediate & Expert Level (such as SQL fundamentals, SQL essential, intermediary SQL & advanced SQL).

  • This course is for you if you are tired of SQL courses that are too brief, too simple, or too complicated.

  • This course is for you if you want to build a real-world database, reports with Tableau, projects with SQL & connect to Python.

  • This course is for you if you want to master the in-and-out of SQL queries including complex and advanced queries.

  • This course is for you if you want to learn MySQL by doing exciting real-life challenges that will distinguish you from the crowd.

  • This course is for you if you want to learn Advanced SQL for Business Analysis, Marketing, and Data Management.

  • This course is for you if you've discovered without SQL you can't do much with data analytics, data science, machine learning, AI, or become a better developer.

  • This course is for you if you want to master SQL which you can also use for Oracle SQL, Microsoft SQL Server, SQL Lite, and PostgreSQL.

  • This MySQL tutorial course is for you if you plan to pass SQL Interview for Data, Business, and Financial Analytics, Data Science, Data Modeller, & Database administration.

  • This course will teach you in detail such as stored procedures, view, transactions, functions, nested and correlated subquery, and several other tips you don't in other MySQL courses.

Requirements

  • No prior knowledge of SQL is required
  • Access to a computer and internet connection
  • And the willingness to learn

Career path

  • SQL Data Analysts: $107,330 Per Year
  • SQL Developer: $124,000 Per Year
  • SQL Database Administrators: $131,000 Per Year

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Database, MySQL, SQL, IT, Coding
Related searches: Data analysis courses, Analytics courses, Online courses